Help!!! Caculate working hours.

Hi Kanin,

The error is that you are attempting to add two durations and a number. You need to ensure that the value in each of the cells to be summed is a Duration. The revised formula will do that.

Existing formula: =C2-B2

Replace with: =IF(OR(LEN(B)<1,LEN(C)<1),DURATION(,,,0),C-B)

The formula says: If cell B or cell C is empty, the result is 0m (zero minutes), otherwise, the result is C-B.

Note: Numbers is 'smart' enough to recognize when 'B' means 'all of column B' and when 'B' means 'the single cell in this row of column B', which is why I've left the 2 off of each of the four cell references in this formula.

Regards,

Barry

Hi Kanin,

D2 worked before because you had Date/Time values in B2 and C2. It would also have worked when B2 and C2 were empty, but would have produced a result of 0 (a number)

What result do you see in D9? If it is an error triangle, what is the error message? (click once on the triangle to show the message)

I notice what's displayed in D9 does not start with an = sign. Did you enter one before entering the formula?

Your formulas are being displayed as text. Displaying them with the formatting applied in the Formula Editor is more useful, as the display shows whether Numbers is recognizing all parts of the formula. When you double click on a cell containing a formula, the formula is displayed in the formula Editor, and should look like this:

Note that this display also shows the result produced by the formula, which can also be useful information.

Regards,

Barry